package com.ray.depot.table.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class SupplierExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected int limitStart = -1;

    protected int limitEnd = -1;

    /**
     *
     */
    public SupplierExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     *
     * @param orderByClause
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     *
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     *
     * @param distinct
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     *
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     *
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     *
     * @param criteria
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     *
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     *
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     *
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     *
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     *
     * @param limitStart
     */
    public void setLimitStart(int limitStart) {
        this.limitStart=limitStart;
    }

    /**
     *
     */
    public int getLimitStart() {
        return limitStart;
    }

    /**
     *
     * @param limitEnd
     */
    public void setLimitEnd(int limitEnd) {
        this.limitEnd=limitEnd;
    }

    /**
     *
     */
    public int getLimitEnd() {
        return limitEnd;
    }

    /**
     * 类注释
     * GeneratedCriteria
     * 数据库表：dpt_supplier
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andSupplierIdIsNull() {
            addCriterion("SUPPLIER_ID is null");
            return (Criteria) this;
        }

        public Criteria andSupplierIdIsNotNull() {
            addCriterion("SUPPLIER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierIdEqualTo(String value) {
            addCriterion("SUPPLIER_ID =", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdNotEqualTo(String value) {
            addCriterion("SUPPLIER_ID <>", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdGreaterThan(String value) {
            addCriterion("SUPPLIER_ID >", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdGreaterThanOrEqualTo(String value) {
            addCriterion("SUPPLIER_ID >=", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdLessThan(String value) {
            addCriterion("SUPPLIER_ID <", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdLessThanOrEqualTo(String value) {
            addCriterion("SUPPLIER_ID <=", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdLike(String value) {
            addCriterion("SUPPLIER_ID like", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdNotLike(String value) {
            addCriterion("SUPPLIER_ID not like", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdIn(List<String> values) {
            addCriterion("SUPPLIER_ID in", values, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdNotIn(List<String> values) {
            addCriterion("SUPPLIER_ID not in", values, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdBetween(String value1, String value2) {
            addCriterion("SUPPLIER_ID between", value1, value2, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdNotBetween(String value1, String value2) {
            addCriterion("SUPPLIER_ID not between", value1, value2, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierNameIsNull() {
            addCriterion("SUPPLIER_NAME is null");
            return (Criteria) this;
        }

        public Criteria andSupplierNameIsNotNull() {
            addCriterion("SUPPLIER_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierNameEqualTo(String value) {
            addCriterion("SUPPLIER_NAME =", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameNotEqualTo(String value) {
            addCriterion("SUPPLIER_NAME <>", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameGreaterThan(String value) {
            addCriterion("SUPPLIER_NAME >", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameGreaterThanOrEqualTo(String value) {
            addCriterion("SUPPLIER_NAME >=", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameLessThan(String value) {
            addCriterion("SUPPLIER_NAME <", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameLessThanOrEqualTo(String value) {
            addCriterion("SUPPLIER_NAME <=", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameLike(String value) {
            addCriterion("SUPPLIER_NAME like", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameNotLike(String value) {
            addCriterion("SUPPLIER_NAME not like", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameIn(List<String> values) {
            addCriterion("SUPPLIER_NAME in", values, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameNotIn(List<String> values) {
            addCriterion("SUPPLIER_NAME not in", values, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameBetween(String value1, String value2) {
            addCriterion("SUPPLIER_NAME between", value1, value2, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameNotBetween(String value1, String value2) {
            addCriterion("SUPPLIER_NAME not between", value1, value2, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierTypeIsNull() {
            addCriterion("SUPPLIER_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andSupplierTypeIsNotNull() {
            addCriterion("SUPPLIER_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierTypeEqualTo(String value) {
            addCriterion("SUPPLIER_TYPE =", value, "supplierType");
            return (Criteria) this;
        }

        public Criteria andSupplierTypeNotEqualTo(String value) {
            addCriterion("SUPPLIER_TYPE <>", value, "supplierType");
            return (Criteria) this;
        }

        public Criteria andSupplierTypeGreaterThan(String value) {
            addCriterion("SUPPLIER_TYPE >", value, "supplierType");
            return (Criteria) this;
        }

        public Criteria andSupplierTypeGreaterThanOrEqualTo(String value) {
            addCriterion("SUPPLIER_TYPE >=", value, "supplierType");
            return (Criteria) this;
        }

        public Criteria andSupplierTypeLessThan(String value) {
            addCriterion("SUPPLIER_TYPE <", value, "supplierType");
            return (Criteria) this;
        }

        public Criteria andSupplierTypeLessThanOrEqualTo(String value) {
            addCriterion("SUPPLIER_TYPE <=", value, "supplierType");
            return (Criteria) this;
        }

        public Criteria andSupplierTypeLike(String value) {
            addCriterion("SUPPLIER_TYPE like", value, "supplierType");
            return (Criteria) this;
        }

        public Criteria andSupplierTypeNotLike(String value) {
            addCriterion("SUPPLIER_TYPE not like", value, "supplierType");
            return (Criteria) this;
        }

        public Criteria andSupplierTypeIn(List<String> values) {
            addCriterion("SUPPLIER_TYPE in", values, "supplierType");
            return (Criteria) this;
        }

        public Criteria andSupplierTypeNotIn(List<String> values) {
            addCriterion("SUPPLIER_TYPE not in", values, "supplierType");
            return (Criteria) this;
        }

        public Criteria andSupplierTypeBetween(String value1, String value2) {
            addCriterion("SUPPLIER_TYPE between", value1, value2, "supplierType");
            return (Criteria) this;
        }

        public Criteria andSupplierTypeNotBetween(String value1, String value2) {
            addCriterion("SUPPLIER_TYPE not between", value1, value2, "supplierType");
            return (Criteria) this;
        }

        public Criteria andSupplierLevelIsNull() {
            addCriterion("SUPPLIER_LEVEL is null");
            return (Criteria) this;
        }

        public Criteria andSupplierLevelIsNotNull() {
            addCriterion("SUPPLIER_LEVEL is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierLevelEqualTo(String value) {
            addCriterion("SUPPLIER_LEVEL =", value, "supplierLevel");
            return (Criteria) this;
        }

        public Criteria andSupplierLevelNotEqualTo(String value) {
            addCriterion("SUPPLIER_LEVEL <>", value, "supplierLevel");
            return (Criteria) this;
        }

        public Criteria andSupplierLevelGreaterThan(String value) {
            addCriterion("SUPPLIER_LEVEL >", value, "supplierLevel");
            return (Criteria) this;
        }

        public Criteria andSupplierLevelGreaterThanOrEqualTo(String value) {
            addCriterion("SUPPLIER_LEVEL >=", value, "supplierLevel");
            return (Criteria) this;
        }

        public Criteria andSupplierLevelLessThan(String value) {
            addCriterion("SUPPLIER_LEVEL <", value, "supplierLevel");
            return (Criteria) this;
        }

        public Criteria andSupplierLevelLessThanOrEqualTo(String value) {
            addCriterion("SUPPLIER_LEVEL <=", value, "supplierLevel");
            return (Criteria) this;
        }

        public Criteria andSupplierLevelLike(String value) {
            addCriterion("SUPPLIER_LEVEL like", value, "supplierLevel");
            return (Criteria) this;
        }

        public Criteria andSupplierLevelNotLike(String value) {
            addCriterion("SUPPLIER_LEVEL not like", value, "supplierLevel");
            return (Criteria) this;
        }

        public Criteria andSupplierLevelIn(List<String> values) {
            addCriterion("SUPPLIER_LEVEL in", values, "supplierLevel");
            return (Criteria) this;
        }

        public Criteria andSupplierLevelNotIn(List<String> values) {
            addCriterion("SUPPLIER_LEVEL not in", values, "supplierLevel");
            return (Criteria) this;
        }

        public Criteria andSupplierLevelBetween(String value1, String value2) {
            addCriterion("SUPPLIER_LEVEL between", value1, value2, "supplierLevel");
            return (Criteria) this;
        }

        public Criteria andSupplierLevelNotBetween(String value1, String value2) {
            addCriterion("SUPPLIER_LEVEL not between", value1, value2, "supplierLevel");
            return (Criteria) this;
        }

        public Criteria andSupplierDescIsNull() {
            addCriterion("SUPPLIER_DESC is null");
            return (Criteria) this;
        }

        public Criteria andSupplierDescIsNotNull() {
            addCriterion("SUPPLIER_DESC is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierDescEqualTo(String value) {
            addCriterion("SUPPLIER_DESC =", value, "supplierDesc");
            return (Criteria) this;
        }

        public Criteria andSupplierDescNotEqualTo(String value) {
            addCriterion("SUPPLIER_DESC <>", value, "supplierDesc");
            return (Criteria) this;
        }

        public Criteria andSupplierDescGreaterThan(String value) {
            addCriterion("SUPPLIER_DESC >", value, "supplierDesc");
            return (Criteria) this;
        }

        public Criteria andSupplierDescGreaterThanOrEqualTo(String value) {
            addCriterion("SUPPLIER_DESC >=", value, "supplierDesc");
            return (Criteria) this;
        }

        public Criteria andSupplierDescLessThan(String value) {
            addCriterion("SUPPLIER_DESC <", value, "supplierDesc");
            return (Criteria) this;
        }

        public Criteria andSupplierDescLessThanOrEqualTo(String value) {
            addCriterion("SUPPLIER_DESC <=", value, "supplierDesc");
            return (Criteria) this;
        }

        public Criteria andSupplierDescLike(String value) {
            addCriterion("SUPPLIER_DESC like", value, "supplierDesc");
            return (Criteria) this;
        }

        public Criteria andSupplierDescNotLike(String value) {
            addCriterion("SUPPLIER_DESC not like", value, "supplierDesc");
            return (Criteria) this;
        }

        public Criteria andSupplierDescIn(List<String> values) {
            addCriterion("SUPPLIER_DESC in", values, "supplierDesc");
            return (Criteria) this;
        }

        public Criteria andSupplierDescNotIn(List<String> values) {
            addCriterion("SUPPLIER_DESC not in", values, "supplierDesc");
            return (Criteria) this;
        }

        public Criteria andSupplierDescBetween(String value1, String value2) {
            addCriterion("SUPPLIER_DESC between", value1, value2, "supplierDesc");
            return (Criteria) this;
        }

        public Criteria andSupplierDescNotBetween(String value1, String value2) {
            addCriterion("SUPPLIER_DESC not between", value1, value2, "supplierDesc");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeIsNull() {
            addCriterion("MNEMONIC_CODE is null");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeIsNotNull() {
            addCriterion("MNEMONIC_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeEqualTo(String value) {
            addCriterion("MNEMONIC_CODE =", value, "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeNotEqualTo(String value) {
            addCriterion("MNEMONIC_CODE <>", value, "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeGreaterThan(String value) {
            addCriterion("MNEMONIC_CODE >", value, "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeGreaterThanOrEqualTo(String value) {
            addCriterion("MNEMONIC_CODE >=", value, "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeLessThan(String value) {
            addCriterion("MNEMONIC_CODE <", value, "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeLessThanOrEqualTo(String value) {
            addCriterion("MNEMONIC_CODE <=", value, "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeLike(String value) {
            addCriterion("MNEMONIC_CODE like", value, "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeNotLike(String value) {
            addCriterion("MNEMONIC_CODE not like", value, "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeIn(List<String> values) {
            addCriterion("MNEMONIC_CODE in", values, "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeNotIn(List<String> values) {
            addCriterion("MNEMONIC_CODE not in", values, "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeBetween(String value1, String value2) {
            addCriterion("MNEMONIC_CODE between", value1, value2, "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeNotBetween(String value1, String value2) {
            addCriterion("MNEMONIC_CODE not between", value1, value2, "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andCityIsNull() {
            addCriterion("CITY is null");
            return (Criteria) this;
        }

        public Criteria andCityIsNotNull() {
            addCriterion("CITY is not null");
            return (Criteria) this;
        }

        public Criteria andCityEqualTo(String value) {
            addCriterion("CITY =", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotEqualTo(String value) {
            addCriterion("CITY <>", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThan(String value) {
            addCriterion("CITY >", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThanOrEqualTo(String value) {
            addCriterion("CITY >=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThan(String value) {
            addCriterion("CITY <", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThanOrEqualTo(String value) {
            addCriterion("CITY <=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLike(String value) {
            addCriterion("CITY like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotLike(String value) {
            addCriterion("CITY not like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityIn(List<String> values) {
            addCriterion("CITY in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotIn(List<String> values) {
            addCriterion("CITY not in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityBetween(String value1, String value2) {
            addCriterion("CITY between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotBetween(String value1, String value2) {
            addCriterion("CITY not between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNull() {
            addCriterion("PROVINCE is null");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNotNull() {
            addCriterion("PROVINCE is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceEqualTo(String value) {
            addCriterion("PROVINCE =", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotEqualTo(String value) {
            addCriterion("PROVINCE <>", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThan(String value) {
            addCriterion("PROVINCE >", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThanOrEqualTo(String value) {
            addCriterion("PROVINCE >=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThan(String value) {
            addCriterion("PROVINCE <", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThanOrEqualTo(String value) {
            addCriterion("PROVINCE <=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLike(String value) {
            addCriterion("PROVINCE like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotLike(String value) {
            addCriterion("PROVINCE not like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceIn(List<String> values) {
            addCriterion("PROVINCE in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotIn(List<String> values) {
            addCriterion("PROVINCE not in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceBetween(String value1, String value2) {
            addCriterion("PROVINCE between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotBetween(String value1, String value2) {
            addCriterion("PROVINCE not between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andCountyIsNull() {
            addCriterion("COUNTY is null");
            return (Criteria) this;
        }

        public Criteria andCountyIsNotNull() {
            addCriterion("COUNTY is not null");
            return (Criteria) this;
        }

        public Criteria andCountyEqualTo(String value) {
            addCriterion("COUNTY =", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyNotEqualTo(String value) {
            addCriterion("COUNTY <>", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyGreaterThan(String value) {
            addCriterion("COUNTY >", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyGreaterThanOrEqualTo(String value) {
            addCriterion("COUNTY >=", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyLessThan(String value) {
            addCriterion("COUNTY <", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyLessThanOrEqualTo(String value) {
            addCriterion("COUNTY <=", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyLike(String value) {
            addCriterion("COUNTY like", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyNotLike(String value) {
            addCriterion("COUNTY not like", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyIn(List<String> values) {
            addCriterion("COUNTY in", values, "county");
            return (Criteria) this;
        }

        public Criteria andCountyNotIn(List<String> values) {
            addCriterion("COUNTY not in", values, "county");
            return (Criteria) this;
        }

        public Criteria andCountyBetween(String value1, String value2) {
            addCriterion("COUNTY between", value1, value2, "county");
            return (Criteria) this;
        }

        public Criteria andCountyNotBetween(String value1, String value2) {
            addCriterion("COUNTY not between", value1, value2, "county");
            return (Criteria) this;
        }

        public Criteria andStreetIsNull() {
            addCriterion("STREET is null");
            return (Criteria) this;
        }

        public Criteria andStreetIsNotNull() {
            addCriterion("STREET is not null");
            return (Criteria) this;
        }

        public Criteria andStreetEqualTo(String value) {
            addCriterion("STREET =", value, "street");
            return (Criteria) this;
        }

        public Criteria andStreetNotEqualTo(String value) {
            addCriterion("STREET <>", value, "street");
            return (Criteria) this;
        }

        public Criteria andStreetGreaterThan(String value) {
            addCriterion("STREET >", value, "street");
            return (Criteria) this;
        }

        public Criteria andStreetGreaterThanOrEqualTo(String value) {
            addCriterion("STREET >=", value, "street");
            return (Criteria) this;
        }

        public Criteria andStreetLessThan(String value) {
            addCriterion("STREET <", value, "street");
            return (Criteria) this;
        }

        public Criteria andStreetLessThanOrEqualTo(String value) {
            addCriterion("STREET <=", value, "street");
            return (Criteria) this;
        }

        public Criteria andStreetLike(String value) {
            addCriterion("STREET like", value, "street");
            return (Criteria) this;
        }

        public Criteria andStreetNotLike(String value) {
            addCriterion("STREET not like", value, "street");
            return (Criteria) this;
        }

        public Criteria andStreetIn(List<String> values) {
            addCriterion("STREET in", values, "street");
            return (Criteria) this;
        }

        public Criteria andStreetNotIn(List<String> values) {
            addCriterion("STREET not in", values, "street");
            return (Criteria) this;
        }

        public Criteria andStreetBetween(String value1, String value2) {
            addCriterion("STREET between", value1, value2, "street");
            return (Criteria) this;
        }

        public Criteria andStreetNotBetween(String value1, String value2) {
            addCriterion("STREET not between", value1, value2, "street");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("ADDRESS is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("ADDRESS is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("ADDRESS =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("ADDRESS <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("ADDRESS >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("ADDRESS >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("ADDRESS <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("ADDRESS <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("ADDRESS like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("ADDRESS not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("ADDRESS in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("ADDRESS not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("ADDRESS between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("ADDRESS not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andTelIsNull() {
            addCriterion("TEL is null");
            return (Criteria) this;
        }

        public Criteria andTelIsNotNull() {
            addCriterion("TEL is not null");
            return (Criteria) this;
        }

        public Criteria andTelEqualTo(String value) {
            addCriterion("TEL =", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelNotEqualTo(String value) {
            addCriterion("TEL <>", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelGreaterThan(String value) {
            addCriterion("TEL >", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelGreaterThanOrEqualTo(String value) {
            addCriterion("TEL >=", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelLessThan(String value) {
            addCriterion("TEL <", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelLessThanOrEqualTo(String value) {
            addCriterion("TEL <=", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelLike(String value) {
            addCriterion("TEL like", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelNotLike(String value) {
            addCriterion("TEL not like", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelIn(List<String> values) {
            addCriterion("TEL in", values, "tel");
            return (Criteria) this;
        }

        public Criteria andTelNotIn(List<String> values) {
            addCriterion("TEL not in", values, "tel");
            return (Criteria) this;
        }

        public Criteria andTelBetween(String value1, String value2) {
            addCriterion("TEL between", value1, value2, "tel");
            return (Criteria) this;
        }

        public Criteria andTelNotBetween(String value1, String value2) {
            addCriterion("TEL not between", value1, value2, "tel");
            return (Criteria) this;
        }

        public Criteria andFaxIsNull() {
            addCriterion("FAX is null");
            return (Criteria) this;
        }

        public Criteria andFaxIsNotNull() {
            addCriterion("FAX is not null");
            return (Criteria) this;
        }

        public Criteria andFaxEqualTo(String value) {
            addCriterion("FAX =", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotEqualTo(String value) {
            addCriterion("FAX <>", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxGreaterThan(String value) {
            addCriterion("FAX >", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxGreaterThanOrEqualTo(String value) {
            addCriterion("FAX >=", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLessThan(String value) {
            addCriterion("FAX <", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLessThanOrEqualTo(String value) {
            addCriterion("FAX <=", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLike(String value) {
            addCriterion("FAX like", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotLike(String value) {
            addCriterion("FAX not like", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxIn(List<String> values) {
            addCriterion("FAX in", values, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotIn(List<String> values) {
            addCriterion("FAX not in", values, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxBetween(String value1, String value2) {
            addCriterion("FAX between", value1, value2, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotBetween(String value1, String value2) {
            addCriterion("FAX not between", value1, value2, "fax");
            return (Criteria) this;
        }

        public Criteria andManagerNameIsNull() {
            addCriterion("MANAGER_NAME is null");
            return (Criteria) this;
        }

        public Criteria andManagerNameIsNotNull() {
            addCriterion("MANAGER_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andManagerNameEqualTo(String value) {
            addCriterion("MANAGER_NAME =", value, "managerName");
            return (Criteria) this;
        }

        public Criteria andManagerNameNotEqualTo(String value) {
            addCriterion("MANAGER_NAME <>", value, "managerName");
            return (Criteria) this;
        }

        public Criteria andManagerNameGreaterThan(String value) {
            addCriterion("MANAGER_NAME >", value, "managerName");
            return (Criteria) this;
        }

        public Criteria andManagerNameGreaterThanOrEqualTo(String value) {
            addCriterion("MANAGER_NAME >=", value, "managerName");
            return (Criteria) this;
        }

        public Criteria andManagerNameLessThan(String value) {
            addCriterion("MANAGER_NAME <", value, "managerName");
            return (Criteria) this;
        }

        public Criteria andManagerNameLessThanOrEqualTo(String value) {
            addCriterion("MANAGER_NAME <=", value, "managerName");
            return (Criteria) this;
        }

        public Criteria andManagerNameLike(String value) {
            addCriterion("MANAGER_NAME like", value, "managerName");
            return (Criteria) this;
        }

        public Criteria andManagerNameNotLike(String value) {
            addCriterion("MANAGER_NAME not like", value, "managerName");
            return (Criteria) this;
        }

        public Criteria andManagerNameIn(List<String> values) {
            addCriterion("MANAGER_NAME in", values, "managerName");
            return (Criteria) this;
        }

        public Criteria andManagerNameNotIn(List<String> values) {
            addCriterion("MANAGER_NAME not in", values, "managerName");
            return (Criteria) this;
        }

        public Criteria andManagerNameBetween(String value1, String value2) {
            addCriterion("MANAGER_NAME between", value1, value2, "managerName");
            return (Criteria) this;
        }

        public Criteria andManagerNameNotBetween(String value1, String value2) {
            addCriterion("MANAGER_NAME not between", value1, value2, "managerName");
            return (Criteria) this;
        }

        public Criteria andManagerTelIsNull() {
            addCriterion("MANAGER_TEL is null");
            return (Criteria) this;
        }

        public Criteria andManagerTelIsNotNull() {
            addCriterion("MANAGER_TEL is not null");
            return (Criteria) this;
        }

        public Criteria andManagerTelEqualTo(String value) {
            addCriterion("MANAGER_TEL =", value, "managerTel");
            return (Criteria) this;
        }

        public Criteria andManagerTelNotEqualTo(String value) {
            addCriterion("MANAGER_TEL <>", value, "managerTel");
            return (Criteria) this;
        }

        public Criteria andManagerTelGreaterThan(String value) {
            addCriterion("MANAGER_TEL >", value, "managerTel");
            return (Criteria) this;
        }

        public Criteria andManagerTelGreaterThanOrEqualTo(String value) {
            addCriterion("MANAGER_TEL >=", value, "managerTel");
            return (Criteria) this;
        }

        public Criteria andManagerTelLessThan(String value) {
            addCriterion("MANAGER_TEL <", value, "managerTel");
            return (Criteria) this;
        }

        public Criteria andManagerTelLessThanOrEqualTo(String value) {
            addCriterion("MANAGER_TEL <=", value, "managerTel");
            return (Criteria) this;
        }

        public Criteria andManagerTelLike(String value) {
            addCriterion("MANAGER_TEL like", value, "managerTel");
            return (Criteria) this;
        }

        public Criteria andManagerTelNotLike(String value) {
            addCriterion("MANAGER_TEL not like", value, "managerTel");
            return (Criteria) this;
        }

        public Criteria andManagerTelIn(List<String> values) {
            addCriterion("MANAGER_TEL in", values, "managerTel");
            return (Criteria) this;
        }

        public Criteria andManagerTelNotIn(List<String> values) {
            addCriterion("MANAGER_TEL not in", values, "managerTel");
            return (Criteria) this;
        }

        public Criteria andManagerTelBetween(String value1, String value2) {
            addCriterion("MANAGER_TEL between", value1, value2, "managerTel");
            return (Criteria) this;
        }

        public Criteria andManagerTelNotBetween(String value1, String value2) {
            addCriterion("MANAGER_TEL not between", value1, value2, "managerTel");
            return (Criteria) this;
        }

        public Criteria andSupplierStatusIsNull() {
            addCriterion("SUPPLIER_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andSupplierStatusIsNotNull() {
            addCriterion("SUPPLIER_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierStatusEqualTo(String value) {
            addCriterion("SUPPLIER_STATUS =", value, "supplierStatus");
            return (Criteria) this;
        }

        public Criteria andSupplierStatusNotEqualTo(String value) {
            addCriterion("SUPPLIER_STATUS <>", value, "supplierStatus");
            return (Criteria) this;
        }

        public Criteria andSupplierStatusGreaterThan(String value) {
            addCriterion("SUPPLIER_STATUS >", value, "supplierStatus");
            return (Criteria) this;
        }

        public Criteria andSupplierStatusGreaterThanOrEqualTo(String value) {
            addCriterion("SUPPLIER_STATUS >=", value, "supplierStatus");
            return (Criteria) this;
        }

        public Criteria andSupplierStatusLessThan(String value) {
            addCriterion("SUPPLIER_STATUS <", value, "supplierStatus");
            return (Criteria) this;
        }

        public Criteria andSupplierStatusLessThanOrEqualTo(String value) {
            addCriterion("SUPPLIER_STATUS <=", value, "supplierStatus");
            return (Criteria) this;
        }

        public Criteria andSupplierStatusLike(String value) {
            addCriterion("SUPPLIER_STATUS like", value, "supplierStatus");
            return (Criteria) this;
        }

        public Criteria andSupplierStatusNotLike(String value) {
            addCriterion("SUPPLIER_STATUS not like", value, "supplierStatus");
            return (Criteria) this;
        }

        public Criteria andSupplierStatusIn(List<String> values) {
            addCriterion("SUPPLIER_STATUS in", values, "supplierStatus");
            return (Criteria) this;
        }

        public Criteria andSupplierStatusNotIn(List<String> values) {
            addCriterion("SUPPLIER_STATUS not in", values, "supplierStatus");
            return (Criteria) this;
        }

        public Criteria andSupplierStatusBetween(String value1, String value2) {
            addCriterion("SUPPLIER_STATUS between", value1, value2, "supplierStatus");
            return (Criteria) this;
        }

        public Criteria andSupplierStatusNotBetween(String value1, String value2) {
            addCriterion("SUPPLIER_STATUS not between", value1, value2, "supplierStatus");
            return (Criteria) this;
        }

        public Criteria andIndexSortIsNull() {
            addCriterion("INDEX_SORT is null");
            return (Criteria) this;
        }

        public Criteria andIndexSortIsNotNull() {
            addCriterion("INDEX_SORT is not null");
            return (Criteria) this;
        }

        public Criteria andIndexSortEqualTo(Integer value) {
            addCriterion("INDEX_SORT =", value, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortNotEqualTo(Integer value) {
            addCriterion("INDEX_SORT <>", value, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortGreaterThan(Integer value) {
            addCriterion("INDEX_SORT >", value, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortGreaterThanOrEqualTo(Integer value) {
            addCriterion("INDEX_SORT >=", value, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortLessThan(Integer value) {
            addCriterion("INDEX_SORT <", value, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortLessThanOrEqualTo(Integer value) {
            addCriterion("INDEX_SORT <=", value, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortIn(List<Integer> values) {
            addCriterion("INDEX_SORT in", values, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortNotIn(List<Integer> values) {
            addCriterion("INDEX_SORT not in", values, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortBetween(Integer value1, Integer value2) {
            addCriterion("INDEX_SORT between", value1, value2, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortNotBetween(Integer value1, Integer value2) {
            addCriterion("INDEX_SORT not between", value1, value2, "indexSort");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("CREATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("CREATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("CREATE_TIME =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("CREATE_TIME <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("CREATE_TIME >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("CREATE_TIME <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("CREATE_TIME in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("CREATE_TIME not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgIsNull() {
            addCriterion("CREATE_BY_ORG is null");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgIsNotNull() {
            addCriterion("CREATE_BY_ORG is not null");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgEqualTo(String value) {
            addCriterion("CREATE_BY_ORG =", value, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgNotEqualTo(String value) {
            addCriterion("CREATE_BY_ORG <>", value, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgGreaterThan(String value) {
            addCriterion("CREATE_BY_ORG >", value, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_BY_ORG >=", value, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgLessThan(String value) {
            addCriterion("CREATE_BY_ORG <", value, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgLessThanOrEqualTo(String value) {
            addCriterion("CREATE_BY_ORG <=", value, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgLike(String value) {
            addCriterion("CREATE_BY_ORG like", value, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgNotLike(String value) {
            addCriterion("CREATE_BY_ORG not like", value, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgIn(List<String> values) {
            addCriterion("CREATE_BY_ORG in", values, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgNotIn(List<String> values) {
            addCriterion("CREATE_BY_ORG not in", values, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgBetween(String value1, String value2) {
            addCriterion("CREATE_BY_ORG between", value1, value2, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgNotBetween(String value1, String value2) {
            addCriterion("CREATE_BY_ORG not between", value1, value2, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByUserIsNull() {
            addCriterion("CREATE_BY_USER is null");
            return (Criteria) this;
        }

        public Criteria andCreateByUserIsNotNull() {
            addCriterion("CREATE_BY_USER is not null");
            return (Criteria) this;
        }

        public Criteria andCreateByUserEqualTo(String value) {
            addCriterion("CREATE_BY_USER =", value, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserNotEqualTo(String value) {
            addCriterion("CREATE_BY_USER <>", value, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserGreaterThan(String value) {
            addCriterion("CREATE_BY_USER >", value, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_BY_USER >=", value, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserLessThan(String value) {
            addCriterion("CREATE_BY_USER <", value, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserLessThanOrEqualTo(String value) {
            addCriterion("CREATE_BY_USER <=", value, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserLike(String value) {
            addCriterion("CREATE_BY_USER like", value, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserNotLike(String value) {
            addCriterion("CREATE_BY_USER not like", value, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserIn(List<String> values) {
            addCriterion("CREATE_BY_USER in", values, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserNotIn(List<String> values) {
            addCriterion("CREATE_BY_USER not in", values, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserBetween(String value1, String value2) {
            addCriterion("CREATE_BY_USER between", value1, value2, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserNotBetween(String value1, String value2) {
            addCriterion("CREATE_BY_USER not between", value1, value2, "createByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("UPDATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("UPDATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("UPDATE_TIME =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("UPDATE_TIME <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("UPDATE_TIME >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("UPDATE_TIME <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("UPDATE_TIME in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("UPDATE_TIME not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgIsNull() {
            addCriterion("UPDATE_BY_ORG is null");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgIsNotNull() {
            addCriterion("UPDATE_BY_ORG is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgEqualTo(String value) {
            addCriterion("UPDATE_BY_ORG =", value, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgNotEqualTo(String value) {
            addCriterion("UPDATE_BY_ORG <>", value, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgGreaterThan(String value) {
            addCriterion("UPDATE_BY_ORG >", value, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATE_BY_ORG >=", value, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgLessThan(String value) {
            addCriterion("UPDATE_BY_ORG <", value, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgLessThanOrEqualTo(String value) {
            addCriterion("UPDATE_BY_ORG <=", value, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgLike(String value) {
            addCriterion("UPDATE_BY_ORG like", value, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgNotLike(String value) {
            addCriterion("UPDATE_BY_ORG not like", value, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgIn(List<String> values) {
            addCriterion("UPDATE_BY_ORG in", values, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgNotIn(List<String> values) {
            addCriterion("UPDATE_BY_ORG not in", values, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgBetween(String value1, String value2) {
            addCriterion("UPDATE_BY_ORG between", value1, value2, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgNotBetween(String value1, String value2) {
            addCriterion("UPDATE_BY_ORG not between", value1, value2, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserIsNull() {
            addCriterion("UPDATE_BY_USER is null");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserIsNotNull() {
            addCriterion("UPDATE_BY_USER is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserEqualTo(String value) {
            addCriterion("UPDATE_BY_USER =", value, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserNotEqualTo(String value) {
            addCriterion("UPDATE_BY_USER <>", value, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserGreaterThan(String value) {
            addCriterion("UPDATE_BY_USER >", value, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATE_BY_USER >=", value, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserLessThan(String value) {
            addCriterion("UPDATE_BY_USER <", value, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserLessThanOrEqualTo(String value) {
            addCriterion("UPDATE_BY_USER <=", value, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserLike(String value) {
            addCriterion("UPDATE_BY_USER like", value, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserNotLike(String value) {
            addCriterion("UPDATE_BY_USER not like", value, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserIn(List<String> values) {
            addCriterion("UPDATE_BY_USER in", values, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserNotIn(List<String> values) {
            addCriterion("UPDATE_BY_USER not in", values, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserBetween(String value1, String value2) {
            addCriterion("UPDATE_BY_USER between", value1, value2, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserNotBetween(String value1, String value2) {
            addCriterion("UPDATE_BY_USER not between", value1, value2, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andIsDeleteIsNull() {
            addCriterion("IS_DELETE is null");
            return (Criteria) this;
        }

        public Criteria andIsDeleteIsNotNull() {
            addCriterion("IS_DELETE is not null");
            return (Criteria) this;
        }

        public Criteria andIsDeleteEqualTo(String value) {
            addCriterion("IS_DELETE =", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotEqualTo(String value) {
            addCriterion("IS_DELETE <>", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteGreaterThan(String value) {
            addCriterion("IS_DELETE >", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteGreaterThanOrEqualTo(String value) {
            addCriterion("IS_DELETE >=", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteLessThan(String value) {
            addCriterion("IS_DELETE <", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteLessThanOrEqualTo(String value) {
            addCriterion("IS_DELETE <=", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteLike(String value) {
            addCriterion("IS_DELETE like", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotLike(String value) {
            addCriterion("IS_DELETE not like", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteIn(List<String> values) {
            addCriterion("IS_DELETE in", values, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotIn(List<String> values) {
            addCriterion("IS_DELETE not in", values, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteBetween(String value1, String value2) {
            addCriterion("IS_DELETE between", value1, value2, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotBetween(String value1, String value2) {
            addCriterion("IS_DELETE not between", value1, value2, "isDelete");
            return (Criteria) this;
        }

        public Criteria andTenantIdIsNull() {
            addCriterion("TENANT_ID is null");
            return (Criteria) this;
        }

        public Criteria andTenantIdIsNotNull() {
            addCriterion("TENANT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andTenantIdEqualTo(String value) {
            addCriterion("TENANT_ID =", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdNotEqualTo(String value) {
            addCriterion("TENANT_ID <>", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdGreaterThan(String value) {
            addCriterion("TENANT_ID >", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdGreaterThanOrEqualTo(String value) {
            addCriterion("TENANT_ID >=", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdLessThan(String value) {
            addCriterion("TENANT_ID <", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdLessThanOrEqualTo(String value) {
            addCriterion("TENANT_ID <=", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdLike(String value) {
            addCriterion("TENANT_ID like", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdNotLike(String value) {
            addCriterion("TENANT_ID not like", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdIn(List<String> values) {
            addCriterion("TENANT_ID in", values, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdNotIn(List<String> values) {
            addCriterion("TENANT_ID not in", values, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdBetween(String value1, String value2) {
            addCriterion("TENANT_ID between", value1, value2, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdNotBetween(String value1, String value2) {
            addCriterion("TENANT_ID not between", value1, value2, "tenantId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdLikeInsensitive(String value) {
            addCriterion("upper(SUPPLIER_ID) like", value.toUpperCase(), "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierNameLikeInsensitive(String value) {
            addCriterion("upper(SUPPLIER_NAME) like", value.toUpperCase(), "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierTypeLikeInsensitive(String value) {
            addCriterion("upper(SUPPLIER_TYPE) like", value.toUpperCase(), "supplierType");
            return (Criteria) this;
        }

        public Criteria andSupplierLevelLikeInsensitive(String value) {
            addCriterion("upper(SUPPLIER_LEVEL) like", value.toUpperCase(), "supplierLevel");
            return (Criteria) this;
        }

        public Criteria andSupplierDescLikeInsensitive(String value) {
            addCriterion("upper(SUPPLIER_DESC) like", value.toUpperCase(), "supplierDesc");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeLikeInsensitive(String value) {
            addCriterion("upper(MNEMONIC_CODE) like", value.toUpperCase(), "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andCityLikeInsensitive(String value) {
            addCriterion("upper(CITY) like", value.toUpperCase(), "city");
            return (Criteria) this;
        }

        public Criteria andProvinceLikeInsensitive(String value) {
            addCriterion("upper(PROVINCE) like", value.toUpperCase(), "province");
            return (Criteria) this;
        }

        public Criteria andCountyLikeInsensitive(String value) {
            addCriterion("upper(COUNTY) like", value.toUpperCase(), "county");
            return (Criteria) this;
        }

        public Criteria andStreetLikeInsensitive(String value) {
            addCriterion("upper(STREET) like", value.toUpperCase(), "street");
            return (Criteria) this;
        }

        public Criteria andAddressLikeInsensitive(String value) {
            addCriterion("upper(ADDRESS) like", value.toUpperCase(), "address");
            return (Criteria) this;
        }

        public Criteria andTelLikeInsensitive(String value) {
            addCriterion("upper(TEL) like", value.toUpperCase(), "tel");
            return (Criteria) this;
        }

        public Criteria andFaxLikeInsensitive(String value) {
            addCriterion("upper(FAX) like", value.toUpperCase(), "fax");
            return (Criteria) this;
        }

        public Criteria andManagerNameLikeInsensitive(String value) {
            addCriterion("upper(MANAGER_NAME) like", value.toUpperCase(), "managerName");
            return (Criteria) this;
        }

        public Criteria andManagerTelLikeInsensitive(String value) {
            addCriterion("upper(MANAGER_TEL) like", value.toUpperCase(), "managerTel");
            return (Criteria) this;
        }

        public Criteria andSupplierStatusLikeInsensitive(String value) {
            addCriterion("upper(SUPPLIER_STATUS) like", value.toUpperCase(), "supplierStatus");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgLikeInsensitive(String value) {
            addCriterion("upper(CREATE_BY_ORG) like", value.toUpperCase(), "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByUserLikeInsensitive(String value) {
            addCriterion("upper(CREATE_BY_USER) like", value.toUpperCase(), "createByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgLikeInsensitive(String value) {
            addCriterion("upper(UPDATE_BY_ORG) like", value.toUpperCase(), "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserLikeInsensitive(String value) {
            addCriterion("upper(UPDATE_BY_USER) like", value.toUpperCase(), "updateByUser");
            return (Criteria) this;
        }

        public Criteria andIsDeleteLikeInsensitive(String value) {
            addCriterion("upper(IS_DELETE) like", value.toUpperCase(), "isDelete");
            return (Criteria) this;
        }

        public Criteria andTenantIdLikeInsensitive(String value) {
            addCriterion("upper(TENANT_ID) like", value.toUpperCase(), "tenantId");
            return (Criteria) this;
        }
    }

    /**
     * 类注释
     * Criteria
     * 数据库表：dpt_supplier
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * 类注释
     * Criterion
     * 数据库表：dpt_supplier
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}